Adding Visual card for Sales
Per month, YOY and GPM
Steps
Sales Per Month Visual
Card
Ø Open
Visualization Pane
Ø Select
Visual Card
Ø Drag
the visual to the dashboard.
Ø Click
on Sales Per Month Measure and drag it into the fields.
Ø General:
X - Position = 2, Y - Position = 247, Width = 207, Height = 96
Ø Data
Label: Color = #12239E, Value Decimal =
0, Font Size = 32, Font type = DIN
Ø Category
= OFF
Ø Title
= ON, Text Title = "Sales Per
Month", Font Color = #000000 , Background Color = #cccccc , Font Size = 15 and Font Family = Segoe UI
Bold, Alignment = Center
Ø Background ON, Color = #ffffff, Transparency = 0
Steps
YOY%
Ø Open
Visualization Pane
Ø Select
Visual Card
Ø Drag
the visual on to the dashboard.
Ø Drag
YOY% and place it inside the fields.
Ø General:
X - Position = 0, Y - Position = 383, Width = 207, Height = 110
Ø
Data Label: Color =#E66C37, Value decimal
places = 1, Text Size = 32, Font Family = DIN
Ø
Category = OFF
Ø
Title ON, Text Title = "YOY % Sales",
Font Color = #070606, Background Color = #cccccc, Alignment = Center, Text Size
= 15 and Font Family = Segoe UI Bold
Ø Background = ON, Color = #ffffff, Transparency = 0%
Steps
YOY
Indicator
Ø Open
Visualization Pane
Ø Select
Visual Card
Ø Drag
the visual on to the dashboard.
Ø Click
on Arrow YOY% and place it inside the fields.
Ø General:
X - Position = 148, Y - Position = 417, Width = 70, Height = 50
Ø Data
Label: Text Size = 45, Font Family = DIN, Color: IF YOY > 0 the Data Color will be #0D884D OR
IF YOY < 0 the Data Color will
be #D64550
Ø Category
= OFF, Background = OFF
Gross
Profit Margin (GPM)
Ø Open
Visualization Pane
Ø Select
Visual Card
Ø Drag
the visual on to the dashboard.
Ø Click on the GPM and drag it to the Fields.
ØCheck GPM if it is percentage.
Ø General:
X - Position = 0, Y - Position = 503, Width = 207, Height = 116
Ø Data
Label: Color =#D9B300, Value decimal places = 0, Text Size = 32, Font Family =
DIN
Ø Category
= OFF
Ø Title
ON, Text Title = "Gross Profit Margin", Font Color = #070606,
Background Color = #cccccc , Alignment = Center, Text Size = 15 and Font Family
= Segoe UI Bold
Ø Background = ON, Color = #ffffff, Transparency = 0%
Steps
Refreshed
Date
Ø Open
Visualization Pane
Ø Select
Visual Card
Ø Drag
the visual to the dashboard.
Ø Click
on refreshed date from Data Refresh Table and place it inside the fields.
Ø General:
X - Position = 0, Y - Position =628, Width = 207, Height = 92
Ø Drag
the card to the bottom left corner.
Ø Data
Label: Color = #070606, Font Size = 15, Font type = DIN
Ø Category
= OFF
Ø Title ON, Text Title = " Refreshed Date", Font Color = #070606, Background Color = #cccccc , Font Size = 14 and Font Family = Segoe UI Bold
Create a custom KPI Card in a Power BI report
https://www.youtube.com/watch?v=zHzSBNES6jE
How to Create a Card in Power BI
https://www.tutorialgateway.org/create-a-card-in-power-bi/
How to Add the Last Refreshed Date and Time to a Power
BI Report
https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/